version 14.0
log using "\Users\sgolder\Dropbox\Portfolio Allocation\replication\africancabinets_aux.log", replace
set more off
#delimit ;

*     ***************************************************************** *;
*     ***************************************************************** *;
*       File-Name:      africancabinets_aux.do                          *;
*       Date:           March 22, 2017                                  *;
*       Author:         Molly Ariotti and Sona Golder                   *;
*       Purpose:      	Replicate auxilliary results for CPS portfolio  *;
*                       allocation paper, using Africa data 1990-2014.  *;
* 	    Input File:     aux_cabinet.dta                                 *;
*       Output File:    africancabinets_aux.log                         *;
*       Data Output:    none                                            *;             
*       Previous file:  Africa_govts_aux.xls --> Stata .dta             *;
*       Machine:        laptop                           				*;
*     ****************************************************************  *;
*     ****************************************************************  *;

*     ****************************************************************  *;
*       Open and summarize dataset. This is the Africa_govt_obs.dta     *;
*       with some additional variables: wealth, ethnic heterogeneity,   *;
*       level of democracy, size of cabinet (number of ministers),      *;
*       regime type (parl, pres, semi-pres) and pres (yes or no).       *; 
*       Only coalition governments are included.                        *;
*       Wealth data are from the World Bank, ethnic heterogeneity from  *;
*       Alesina, and level of democracy from Polity IV.                 *;
*     ****************************************************************  *;


use "\Users\sgolder\Dropbox\Portfolio Allocation\replication\aux_cabinet.dta";

sum;

desc;

logit have_data gdp_constant2010usd pres democracy eth_alesina govt_size;

logit have_data gdp_constant2010usd regimetype democracy eth_alesina govt_size;


log close;
exit;
